Schema Evolution for Stars and Snowflakes
نویسندگان
چکیده
The most common implementation platform for multidimensional data warehouses is RDBMSs storing data in relational star and snowflake schemas. DW schemas evolve over time, which may invalidate existing analysis queries used for reporting purposes. However, the evolution properties of star and snowflake schemas have not previously been investigated systematically. This paper systematically investigates the evolution properties of star and snowflake schemas. Eight evolution operations are considered, covering insertion and deletion of dimensions, levels, dimension attributes, and measure attributes. For each operation, the formal semantics of the changes for star and snowflake schemas are given, and instance adaption and impact on existing queries are described. Finally, we compare the evolution properties of star and snowflake schemas, concluding that the star schema is considerably more robust towards schema changes than the snowflake schema.
منابع مشابه
Pulsating red giant and supergiant stars in the Local Group dwarf galaxy Andromeda I
We have conducted an optical long-term monitoring survey of the majority of dwarf galaxies in the Local Group, with the Isaac Newton Telescope (INT), to identify the long period variable (LPV) stars. LPV stars vary on timescales of months to years, and reach the largest amplitudes of their brightness variations at optical wavelengths, due to the changing temperature. They trace stellar populati...
متن کاملOptimizing large star-schema queries with snowflakes via heuristic-based query rewriting
User queries have been becoming increasingly complex (e.g., involving a large number of joins) as database technology is applied to some application domains such as data warehouses and life sciences. Query optimizers in existing database management systems often suffer from intolerably long optimization time and/or poor optimization results when optimizing large join queries. One possible solut...
متن کاملForty Years of X-Ray Binaries
In 2012 it was forty years ago that the discovery of the first X-ray binary Centaurus X-3 became known. That same year it was discovered that apart from the High-Mass X-ray Binaries (HMXBs) there are also Low-Mass X-ray Binaries (LMXBs), and that Cygnus X-1 is most probably a black hole. By 1975 also the new class of Be/X-ray binaries was discovered. After this it took 28 years before ESAs INTE...
متن کاملScaling relations in dynamical evolution of star clusters
We have carried out a series of small scale collisional N-body calculations of single-mass star clusters to investigate the dependence of the lifetime of star clusters on their initial parameters. Our models move through an external galaxy potential with a logarithmic density profile and they are limited by a cut-off radius. In order to find scaling relations between the lifetime of star cluste...
متن کاملDark Halos and Galaxy Evolution
We study the evolution of disk galaxies within the frame of the cold dark matter (CDM) cosmologies. The hydrodynamics of a centrifugally supported gaseous disk and the growth of a stellar disk is calculated in detail taking into account the energy balance of the ISM and the gravitational instabilities that concern gas and stars. The halo density profile is derived from the primordial cosmologic...
متن کامل